package com.lp.dao;

import com.lp.po.PagingVO;
import com.lp.po.Scenery;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface SceneryDao {
    int count();
    int countByName(@Param("sname")String sname);
    List<Scenery> findSceneryAll(PagingVO pagingVO);
    Scenery selectscenerysname(@Param("sname") String sname);
    int insert(Scenery scenery);
    int removeSceneryById(@Param("id") Integer id);
    List<Scenery> findBySceneryName(@Param("toPageNo")Integer toPageNo,@Param("pageSize")Integer pageSize ,@Param("sname")String sname);
    Scenery findBySceneryId(Integer id);
    void updateWhihId(@Param("id") Integer id, @Param("sname")String sname,@Param("latitude")Double latitude,@Param("longitude")Double longitude,
                      @Param("width")Integer width, @Param("tximg")String tximg,@Param("floor")String floor,
                      @Param("description")String description, @Param("scenerylistid")Integer scenerylistid);

    Scenery selectSceneryBIid(@Param("id") Integer id);
    int insertScenery(Scenery id);
    //添加评论后热度加一
    void addGradeWithSceneryId(@Param("id")Integer id,@Param("grade")Integer grade);




    /*小程序模块*/
    List<Scenery> wxfindSceneryAll(Integer scenerylistid);
    List<Scenery> wxfindSceneryByName(String sname);

}